<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="Restoring a Single File or Multiple Files in an Oracle Database (Applicable to 1.6.0 and Later Versions)">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="oracle_gud_0055.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
  <meta name="DC.Publisher" content="20241029">
  <meta name="prodname" content="csbs">
  <meta name="documenttype" content="usermanual">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="EN-US_TOPIC_0000002028898929">
  <meta name="DC.Language" content="en-us">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>Restoring a Single File or Multiple Files in an Oracle Database (Applicable to 1.6.0 and Later Versions)</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="EN-US_TOPIC_0000002028898929"></a><a name="EN-US_TOPIC_0000002028898929"></a>
  <h1 class="topictitle1">Restoring a Single File or Multiple Files in an Oracle Database (Applicable to 1.6.0 and Later Versions)</h1>
  <div>
   <p>This section describes how to restore damaged or lost files in an Oracle database to the Oracle host.</p>
   <div class="section">
    <h4 class="sectiontitle">Context</h4>
    <p>The GUI may vary with versions.</p>
   </div>
   <div class="section">
    <h4 class="sectiontitle">Prerequisites</h4>
    <p>ProtectAgent and other related software have been installed on the target host for restoration.</p>
    <p>For details, see the ProtectAgent Installation Guide.</p>
   </div>
   <div class="section">
    <h4 class="sectiontitle">Procedure</h4>
    <ol>
     <li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000002028898929__en-us_topic_0000001839142377_uicontrol1186171611461"><b><span id="EN-US_TOPIC_0000002028898929__en-us_topic_0000001839142377_text6186101615464"><strong>Explore</strong></span> &gt; <span id="EN-US_TOPIC_0000002028898929__en-us_topic_0000001839142377_text74373665812"><strong>Copy Data</strong></span> &gt; <span id="EN-US_TOPIC_0000002028898929__en-us_topic_0000001839142377_text12413710445"><strong>Databases</strong></span> &gt; <span id="EN-US_TOPIC_0000002028898929__en-us_topic_0000001839142377_text151861216124615"><strong>Oracle</strong></span></b></span>.</span></li>
     <li><span>You can search for copies by database resource or copy. This section uses database resources as an example.</span><p></p><p>On the <span class="wintitle"><b><span><strong>Resources</strong></span></b></span> tab page, locate the database to be restored by database name and then click the database name.</p> <p></p></li>
     <li><span>Specify a copy for restoration.</span><p></p>
      <ol type="a">
       <li>On the <span><strong>By Date</strong></span> tab page, select a year, month, and day in sequence to search for copies.<p>If <span><img src="en-us_image_0000001992371382.png"></span> is displayed under a month or date, copies exist in the month or on the date.</p></li>
       <li>Specify a copy for restoration. Click <span><img src="en-us_image_0000002023178572.png"></span> on the right, locate the row that contains the target copy, and choose <span class="uicontrol"><b>More &gt; Database File Restoration</b></span>.
        <div class="note">
         <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
         <div class="notebody">
          <p>Database files do not support point-in-time restoration.</p>
         </div>
        </div></li>
       <li>Restore the Oracle database to the original location.<p>Select one or more files to be restored under <span class="uicontrol"><b>Data Files</b></span>, <span class="uicontrol"><b>Log Files</b></span>, <span class="uicontrol"><b>Control Files</b></span>, or <span class="uicontrol"><b>Parameter Files</b></span>. Only one type of database files can be selected for restoration.</p>
        <div class="note">
         <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
         <div class="notebody">
          <ul>
           <li>If you set <span class="uicontrol"><b>Target Restoration Location</b></span>, ensure that the path exists on the target host and the database installation user has the read and write permissions on the path. Otherwise, the restoration job will fail. For log copies, you must set <span class="uicontrol"><b>Target Restoration Location</b></span> for the file to be restored.</li>
           <li>If you enable <span class="uicontrol"><b>Modify Database Settings</b></span> when selecting parameter files, you can modify the database settings based on the actual situation of the target host. Incorrect parameter settings will cause a database restoration failure. Database parameters cannot be added or deleted.</li>
          </ul>
         </div>
        </div></li>
      </ol> <p></p></li>
     <li><span>Click <span class="uicontrol"><b><span><strong>OK</strong></span></b></span>.</span></li>
     <li><span>After the file restoration job is complete, the database administrator needs to restore the database based on the restored files. For details, see the <a href="https://docs.oracle.com/search/?q=%2BDatabase%2BBackup%2Band%2BRecovery%2BReference&amp;lang=en" target="_blank" rel="noopener noreferrer">Oracle official document</a>.</span></li>
    </ol>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>Parent topic:</strong> <a href="oracle_gud_0055.html">Restoration</a>
    </div>
   </div>
  </div>
 </body>
</html>